#Clean SpreadSheets

[stirdrawsandreblaws]

hate hitting the point in doing a thing where you're 90% done but the last 10% is a wall because it's about refining everything you've done prior

tedious!!! don't want to!!!! someone take the last bit and make it pretty!!!!! and finished!!!!!!!! please!!!!!!!!!!!

[cjgladback]

I went to my first fiber festival this past weekend! Hoosier Hills Fiber Festival; if I'm still in this state come June next year, I'll probably be back and would love to meet anybody else there. Socializing/hanging out/talking to people without feeling like I was obstructing Real Customers was the one thing I missed, though I didn't really get to any of the free lectures so maybe that's where I could've met some people. Since it was an unknown situation with a lot of people and nearly an hour drive each way, I strategized to make sure I'd go:

First day, I signed up for a couple volunteer shifts. Absolutely a recommended strategy.

Got to be helpful!

They happened to have goodie bags, to help me justify the gas and time (I now have a nice tape measure to replace the one that's been vacationing with a missing sewing kit for a couple years and a lasercut wood two-inch gauge window that might help me with consistency versus my suboptimal practice of just trying to knit perfect squares when swatching in pattern)

I got to learn things about the layout and schedule I wouldn't know to ask when answering questions and acting as a gofer -- especially true working two different locations

And of course, some people were pretty much guaranteed to be happy to see me!

Second day, I signed up for a workshop in the morning so I'd be there and able to shop for anything I needed at the end. Ombre yarn dyeing was the class! It's acid dyes, something I'm several years off from wanting to get into enough to commit to dedicated cookware, full pots of dye powder, etc. The room with the workshop was a barn that had plenty of outlets--but they did not represent plenty of breakers. So there weren't quite enough functional heating elements for the class to have sufficiently cooked our yarn before leaving, and I did need to risk a giant stock pot at home for three batches of four jars, almost-simmering in a water bath for thirty minutes each, of the yarn that hadn't proven it was done (all but the two palest greens). I was a little worried the delay/drawn out heat situation would affect the results but if it did it wasn't much; I got pretty much exactly what I was hoping for with my two color gradient and the single is great too!

The single dye gradient is the color Moss, which did some interesting things with the red portion separating out once they were heated. Every skein has redder blotches, so I'm not bothered about any inconsistency -- if anything it'll help my finished product camouflage stains. Though it was definitely a surprise for me and the other Moss user in the class when our first yarn to have exhausted the dye was the complementary color to what it went in as.

The two color gradient used Rhodamine Red on one end, which was one end of one of our instructor's samples where she chose a cool-green for the other end to show how multi-component dyes mix less predictably than most paint. (It was kinda like shading with markers where you can still see washes of the pink and green in what you squint at and call a grey-brown.) The other end was Cantaloupe, which was one of the maybe three colors she didn't have a sample cut of yarn for. But she described it as the flesh of a perfect ripe cantaloupe and obviously I had to see that, and it sounded like it would be fairly guaranteed to combine nicely with the magenta while being just enough around a bend in the color wheel to be interesting--warm orange versus cool pink. As I said, it turned out pretty much exactly as I was picturing. Not anticipated was how much the jars looked like they were full of some delicious dragonfruit-mango beverage. Were I still a barista I'd be trying to recreate this for my shift drink.

Image descriptions under the cut.

[ID: Five images following fourteen small skeins of sock yarn dyed in individual glass jars, in two gradients. One gradient is six skeins from a medium forest green through a pale creamy pink, the other is eight skeins from a vibrant yellow orange through an even more vibrant magenta. The first photo is inside under fluorescent lights, showing the 32oz glass canning jars with metal lids and rings, full of dye and yarn on a table at the end of the class in which they were filled and heated for a short time.

The next two images are animated gifs. The first gif is two frames showing the finished dye jars sitting in grass, with their yarn and with it removed. The green gradient left only transparent blue color in its jars, and most of the pink to orange gradient's water looks more orange without its yarn, aside from the third and fourth jars from the orange end, which shade toward a neon lilac with the peachy pink yarn removed. The second gif is a view of the inside of the bright green wash bucket, with just the pink-orange yarn in it, then all of them mixed up, all as they were after a soak with the rust-brown water, in the first rinse, and that rinse water alone showing its transparent but still brown tint.

The last two photos show the gradients lined up along a weathered wooden bench on the side of a deck. The first photo has the wet piles of yarn bundled in front of each of their respective jars with remaining dye. The final photo has the clean, dry yarn wound into center-pull balls and still vibrant in the direct sunlight. End ID]

[mrcowboydeanwinchester]

🌸 Sapphicnatural Statistics Spreadsheet 🌸

link for the spreadsheet here!

hello hello! in may 2024 i completed a university essay studying the subversive shipping conventions of sapphicnatural fanfic in the Sapphicnatural Collection over on AO3, with the thesis that sapphicnatural ships are often rarepairs with little-to-no grounds in canon (e.g: a guest character/one-off character who have never met on screen), conversely to standard fanfic practice. as part of this, i gathered some statistics about the fics in the collection, got slightly carried away with the scope, and made a giant spreadsheet with 6 sheets of various data. with the project over, i thought it would be nice to share it with tumblr in case anyone else finds it helpful or just interesting!! i'm likely going to post the essay that i wrote alongside this in the next few weeks, so give me a shout too if that's something you'd like to see

to pique your interest, the spreadsheet includes:

Notes on methodology and the vocabulary used

Statistics on the popularity of each sapphicnatural ship in the collection and the frequency of characters featured

Analysis on some significiant ship factors: whether the characters have met in canon and how frequently characters re-occured in the show

'Ship potency', a new framework i'm workshopping to quantify how 'viable/strong' a ship is, specifically when measuring the makeup of femslash ships against mlm ships

i've written up some of the key points i found and some extra analysis about them under the cut, so read more if you're interested! <3

Contextual note: there are 129 fanfics in the Sapphicnatural collection.

Top 5 most popular Sapphicnatural ships:

donna/jody (10 fics)

anna/mary (7 fics)

jo/cassie (6 fics)

anna/ruby (5 fics)

kaia/claire (4 fics)

21 unique ships have 3 fics per ship. 24 unique ships have 2 fics per ship, and 52 unique ships have 1 fic per ship. So, only a quarter (25.3% of ships) have more than 3 fics written about them.

Rarepairs (and thus multishipping) are much more frequent in Sapphicnatural fanfiction than across most fandom fanfic collections which often centre around a specific ship

Have the characters met in canon?

Only 34.2% of ships involve two or more characters who have met on-screen in the show, with 59.6% of ships featuring two or more characters who have never met

4 out of the 5 top ships are between characters who met in the show's canon

BUT the most common dynamic is between two characters who could potentially meet in canon (are alive through the same seasons/at the same location (hell/heaven) at the same time) but who never meet in the show

This idea of 'canon potential' is the most exciting space for a lot of sapphicnatural writers, where finding gaps in the existing narrative and placing two similar women together to explore what their relationship could look often seems to be more inviting than those established on-screen

What is the spread of side/guest/one-off characters in ships?

A third (32.9%) of ships are made-up side/guest character

None of the characters featured are main characters (as none of the women spn characters can be realistically classed as 'main characters' lolol)

17 ships feature at least one one-off character, with 3 being one-off/one-off

Sapphicnatural fanfiction has a unique appreciation for reinforcing attention to minor characters, often as part of a feminist agenda to restore their agency

How frequently are individual characters featured?

Jo Harvelle is the most popular character in the sapphicnatural collection, involved in 15 unique ships across 34 fics. So, over a quarter (26.4%) of the fanfics in the collection feature Jo

Author's note: honestly this could be my individual impact on the collection as a jogirl oops

Mary Winchester is involved in 14 unique ships across 25 ships, so both Jo and Mary are significantly multi-shipped. Mary features twice across the top 5 ships

Sapphicnatural writers often write in service of a particular character rather than a ship - ie. exploring Jo's sapphic identity is more important than who her relationship is with

Charlie, Anna, Ruby, Claire, and Bela are the other characters involved in more than 10 fics each across the collection

Ship potency:

I explain this concept more on the sheet itself, but I essentially assign numerical values to whether a ship is (possible in) canon or not, how frequently characters re-occur in the show, and how popular a ship is respective to the fandom (as sapphicnatural is small, donna/jody is popular with 10 fics, for example)

This is to gain a measure of how 'strong' a ship is, assuming that a standard mlm ship will rank highly in most of these criteria (control variable of destiel ranks 29.5/30, whereas the average potency sum for a sapphicnatural ship is 11.8)

Across the top 5 ships, the average potency sum is 20.9

4/5 of the most popular sapphicnatural ships are in the top 5 for ship potency, with donna/jody, anna/mary, kaia/claire and anna/ruby having strong canon foundations and so high potency ratings.

jo/cassie is irregular as the third most popular ship because they only rank 14th for ship potency, as the pairing have not met on-screen in canon, and features a one-off character

Ships with higher potency sums do tend to be slightly more popular, but there isn't a clear pattern among any of the ships. I'd like to do some more work with this to fine-tune the system

Wordcount, kudos, and hits:

Average wordcount of a fic is 3,511 words. This fits with my other working theory (links to my post about my history essay on women's fiction through the feminist waves) that sapphicnatural writers utilise short stories and one-shots to most succesfully explore sapphic identities

Average kudos is 48, with a median of 13

Average hits is 353, with a median of 122

So: sapphicnatural fanfics receive a fairly low level of interaction, especially when compared to the mlm ships in the Supernatural fandom (destiel, etc). This is in-line with most fandoms and femslash as a whole - a small, dedicated community are reading and writing sapphicnatural

I didn't explore much here, but it would be interesting to go into further depth anout how many fics in the collection are written by different authors, etc

and that's it from me! if you've made it down here, you're an absolute gem and thank you for sticking with me! hope you foundd it as interesting to read through as i did to write up - and that you give the spreadsheet a nosey too if you fancy <3

[the-voldsoy]

It has begun. I'm finally doing it. I'm finally going to map out Edward Pocket/du Perier/etc's life

[permanentbottombunk]

I decided to put my music in a spreadsheet so I can organize it by the emotion it evokes when I listen to it but, I told my brother that it was what I was doing and he said that it was a "stereotypical autistic activity" and that it was "the kind of activity that they talk about on tv shows"

I defended myself by saying, "But it's color coded :(," which only made it worse.

Anyways on other autism news, I Had Forgotten All Emotions And Had To Google A Chart Before Continuing My Spreadsheet

My brother laughed at me because that made the entire thing tie together wonderfully :'(

[skimmeh]

Gimme your favourite hermitcraft/life series FANFICS :)) I'm making a spreadsheet

[frostyclove]

okay its updated / up to date again :)

[academicgangster]

ooh I love when my organization has access to juicy, juicy databases

[thegeminisage]

ok, now that i've watched all of tos (none of the movies yet...) i am going to do the top ten worst and best episodes, according to Me. they are as follows:

WORST EPISODES

10. the savage curtain - idk who thought putting abe lincoln in a cage match with the vulcan version of ghandi against like, ghengis khan and space hitler would be a good idea. but it wasn't. i did like seeing the vulcan father of logic though like "im gonna go sacrifice myself for peace" ok king

9. i, mudd - all of the mudd episodes are bad. he's not charming at all whatsoever. however, this one is better than the other one because uhura gets to pretend to sell out kirk and they're SOOO cute about it. her little giggle when he PICKS HER UP BY HER SHOULDERS and tells her how proud he is. PLEEEEASE

8. charlie x - the entire premise of this episode is that the bad guy is just autistic. and then they make him live on a planet without people because he can't adjust to normal life ???

7. shore leave - obvious racism of this episode aside, the faux-irish jig that played while kirk was being menaced by his extremely unfunny old bully nearly drove me over the edge. we DO love a good mccoy death fakeout tho

6. a piece of the action - if i had any interest in gangster films before this it's all gone now. that being said. i loved when kirk drove the little car. he was so bad at it. he was so happy.

5. mudd's women - like he's literally just selling women?? and the plot twist is that secretly they're ugly?????

4. who mourns for adonias - this is just "what if ALIENS build the pyramids bro" except for the 1960s. nail in the coffin for this one was kirk proudly declaring they didn't needs gods - because they already had the One God, thank you very much!

3. the paradise syndrome - WHY WOULD YOU HAVE NATIVE AMERICANS MISTAKE KIRK FOR GOD. WHY. like i know why but Why. i think the very worst part of this episode was that it had an amnesia plot that would have FUCKED if you had simply removed the people. if there hadn't been people in this it would've been in my top 10 episodes. i think this broke me.

2. the omega glory - this is the same as the last episode except there's no amnesia, and also the "native americans" are white cosplayers who worship the american flag and mistake kirk for god because he can recite the pledge of allegiance yes really. if i had a nickel for every time this happened i'd only have two nickels etc etc at least kirk didn't knock anybody up in this one ig

1. patterns of force - why would you make your two jewish leads wear swastikas and then literally be whipped by nazis. i know he's such a bad person but not even william shatner deserves that. number one worst episode everyone says it's omega glory but it's this one

BEST EPISODES

10. plato's stepchildren - this episode is hard to rank because like it's both good and bad. the torture scenes were genuinely upsetting, especially the ones at the end w/ spock & nurse chapel, because they weren't just violence being inflicted on tied up guys, but they were SUPPOSED to be upsetting, like it was literally the point. and also this episode bears the distinction of THEEE kirk & uhura kiss. literally historic.

9. the trouble with tribbles - i feel like everyone's heard of this but it really is as good as everyone says. sometimes 1960s humor doesn't translate to 2020s humor but it was genuinely hysterical start to finish. also, the distinct trilling sound was so imprinted in my brain i recognized it in the 2009 movie where i had never registered it before.

8. the naked time - aside from the KING SHIT george takei pulled with the fencing this episode also contains the "i am in control of my emotions [sobbing]" moment and kirk & spock LITERALLY having a slapfight. this episode has everything. an absolute masterpiece

7. the empath - i feel like this paired with "the world is hollow and i have touched the sky" really made me a Bones Understander. i feel a little bad about that bc everyone says the characterizations in s3, or actually that the season as a whole, is kinda shaky? but i watched without knowing that and i feel like i Get It now. also, this was the only score i went and relistened to on spotify

6. tholian web - the spock & mccoy episode ever. there's so many things to say about this from the death fakeout to kirk's little space suit but what TRULY got me was the instant and totally nonverbal agreement to lie straight to kirk's face to both preserve personal dignity and troll the shit out of him (while chekov and sulu are like also silently laughing as they listen in no less). what this episode made me realize was that it's a good thing they argue all the time and make kirk play referee because if they were on the same side kirk wouldn't stand a chance. like he'd be finished.

5. the city on the edge of forever - ok, so, this episode made me feel like i was having a mental break. the time travel. spock's little hat. when he watches kirk kiss edith and then goes back into their room to pretend he didn't see anything. mccoy and kirk basically hugging at the end when edith bites it.

4. requiem for methuselah - the first time i watched this i was kinda like :/ because how does kirk fall in love with a woman in FOUR HOURS? that aside the ending scene blew my tits clean off. i paced around my house for like 30 minutes going "what the FUCK was that" because i couldn't simply lie down and sleep after seeing it. rewatching the episode with uh. new context made me like it a little better. but even if it had been garbage the last scene shook me so thoroughly it would still need to be on this list. i'm getting wound up just thinking about it. number one most shocking tos moment.

3. the dagger of the mind - look, i understand that this episode was technically just run-of-the-mill stuff as far as everybody else is concerned but they put james t kirk in a little brainwashing machine. and the machine was shaped like a chair. and it gives people amnesia sometimes. i don't know how i'm expected to behave normally

2. this side of paradise - this is the episode where a flower jizzes on spock and gives him feelings. and look: it's really funny, and there's a lot to love about it. but the ending where kirk hurls verbal abuse at spock for a solid 92 seconds WITHOUT STOPPING followed by: spock beating the shit out of him until he gets his logic back. i have rewatched this perhaps 1,000 times at minimum. what the fuck were they doing

1. conscience of the king - this episode got me into this mess. i don't think i can elaborate further without significant self-incrimination. let's just say what happened was i thought "oh i'll just watch this one tos episode for context for the fanfiction" and one month later i'm writing fic about [redacted] [redacted] [redacted] DON'T WORRY ABOUT IT

ok, that's my list. i thought about doing honorable mentions for episodes that had scenes i liked even though the overall episode didn't make it into my top 10. but then i realized that would mean recapping basically the entire series and this post is already too long. i do have to give the pon farr episode a shoutout though because even though so much of it was offputting there was literally a titty window in kirk's shirt. like, it's the pon farr episode. ok NOW i'm done

[sullencrab]

I discovered this as well when I was cleaning out his house last year, I just really enjoy cleaning other peoples things/for other people.

I just find it very rewarding, immediate results.

Same thing with painting

[hannie-dul-set]

im telling u this entire fic is pretentious.

[ahollowgrave]

gleefully starting a new mod spreadsheet

[billy-royalton]

anyway, we're going to look at some open houses tomorrow which is terrifying!!!!!!!!!

[king-ludwig-ii]

Embarrassed to say that for someone reason my “go to get work done album” aka the album I put on to make myself do work has been Abbey Road. Huge L for my branding

[sirfetchd]

"why isn't bi an option?" all of my other characters are bi i need some variety

[barley-st-band]

hey does anyone know how we’re supposed to survive it all. asking for a friend